package com.whpost.service.dao.t;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.whpost.service.entity.t.THyxx;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

public interface THyxxDao extends BaseMapper<THyxx> {

    @Select("select lsh,tel,pwd,aeskey,aesiv,(select openid from t_wx_user where t_wx_user.lsh=t_hyxx.t_wx_user_lsh) as openid,(select nickname from t_wx_user where t_wx_user.lsh=t_hyxx.t_wx_user_lsh) as name from t_hyxx where lsh=#{id}")
    THyxx getHyxxContainNickname(String id);

    //获取用户aes
    @Select("select aeskey from t_hyxx where lsh=#{lsh}")
    String getAesKey(String lsh);
}